Labels:text | screenshot | font | number | document | menu OCR: Operation Purpose Situation TABLE ACCESS FULL Sequential full-table scan. no WHERE clause is used TABLE ACCESS BY ROWID \ Refhove rows by intemal row kccassing through indexes INDEX UNIQUE SCAN Rethave rows mio a unique index. "@ thique index can be used for a WHERE clause. INDEX RANGE SCAN Retrieve rows vid on index. # holt unique index can be used, of a range of uniquely indexed values is required `AND EQUAL Combine multible index scans. accessing vid indexes connected by AND CONCATENATION Combine multiple index scans. accessing via an index on multiple values SORE ORDER BY Sort rows on column values. OHHORDER BY, clause is used. SORT. UNIQUE Sor rows :eliminating duplicates. the DISTINCT keyword is used SORE JOIN Soft rows; SORT AGGREGATE mapaning for a joint Sont rows and group together MAK MIN.ON COUNT are used. SORTEGROUP BY Sort rows and group together. HRGROUP BY cause is 'used. UNION ALE Combine two sets of records the UNION keyword is used. MINUS Find the difference between two the MINUS keyword is used. sets of records: INTERSECTION Find the rows in common the INTERSECT Keyword is used between two record, sets, VIEW; Return records from a view. o wew is accessed and in subqueries. FILTERS Elintinate rows from a view. 'a WHERE clause is used with a view. MERGE JOIN toin two dobles joining two tables without indexes available. MERGE JOIN OUTER. Join frio tables using on grouter iDin is requested on two tables with- outer jonis out indexed helds. NESTED LOOPS Join two tables. tomning two tables on indexed fields NESTED LOOPS OUTER doin twosables using on an outer join i's requested on two tables with indexed fields Figure 1: Selected Oracle SQL operations.
(2000).iso/delph/991/woodf101.gif){kind=small}
(2000).iso/delph/991/van0f113.gif){kind=link}
(2000).iso/delph/991/woodf102.gif){kind=link}